This takes you into a Page Break Preview mode that shows your worksheet data at a reduced magnification (60 percent of normal) with the page numbers displayed in large, light type and the page breaks shown by heavy lines between the columns and rows of the worksheet.

Here is a worksheet in Page Break Preview with an example of a bad vertical and horizontal page break that you can remedy by adjusting the location of the page break on Pages 1 and 3. Given the page size, orientation, and margin settings for this report, Excel inserts a vertical page break between columns H and I.

This break separates the April, May, and June sales on Page 1 from the Qtr 2 subtotals on Page 3. It also inserts a horizontal page break between rows 27 and 28, splitting the Net Income heading from its data in the rows below.